Skip Headers

Oracle® Database Backup and Recovery Reference 10g Release 2 (10.2) Part Number B14194-03 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# RC_BACKUP_COPY_DETAILS

`RC_BACKUP_COPY_DETAILS` contains detailed information all `AVAILABLE` control file and datafile copies. Columns `SESSION_KEY`, `SESSION_RECID`, `SESSION_STAMP`, and `COPY_KEY` uniquely identify an RMAN session and datafile copy. Other columns for this view have the same semantics as in `RC_DATAFILE_COPY`.

This view is primarily intended to be used internally by Enterprise Manager.

Column | Datatype | Description
--- | --- | ---
`SESSION_KEY` | `NUMBER` | Session identifier. Use in joins with RC_RMAN_OUTPUT.
`SESSION_RECID` | `NUMBER` | Together with SESSION_STAMP, uniquely identifies output for this backup job from RC_RMAN_OUTPUT.
`SESSION_STAMP` | `NUMBER` | Together with SESSION_RECID, uniquely identifies output for this backup job from RC_RMAN_OUTPUT.
`DB_KEY` | `NUMBER` | The primary key for this database in the recovery catalog. Use this column to form a join with almost any other catalog view.
`DB_NAME` | `VARCHAR2(8)` | The `DB_NAME` of the database incarnation to which this record belongs.
`RSR_KEY` | `NUMBER` | Unique key for the row in `RC_RMAN_STATUS` corresponding to the job that created this copy.
`COPY_KEY` | `NUMBER` | Unique identifier for this datafile or control file copy.
`FILE#` | `NUMBER` | The absolute file number for the datafile, for datafile copies.
`NAME` | `VARCHAR2(1024)` | The filename of the datafile or control file copy.
`TAG` | `VARCHAR2(32)` | The tag, if any, for this datafile or control file copy.
`CREATION_CHANGE#` | `NUMBER` | The creation SCN of the datafile, for datafiles.
`CREATION_TIME` | `DATE` | The creation time of the file.
`CHECKPOINT_CHANGE#` | `NUMBER` | The SCN of the most recent datafile checkpoint.
`CHECKPOINT_TIME` | `DATE` | The time of the most recent datafile checkpoint.
`MARKED_CORRUPT` | `NUMBER` | Number of blocks in the datafile that are marked corrupt, based on `RC_DATABASE_BLOCK_CORRUPTION` view.
`OUTPUT_BYTES` | `NUMBER` | Sum of sizes of all output pieces generated by this job.
`COMPLETION_TIME` | `DATE` | The completion time for this file copy.
`CONTROLFILE_TYPE` | `VARCHAR2(1)` | The type of control file backed up, for control file copies: `B` (normal copy) or `S` (standby copy). Otherwise, NULL.
`KEEP` | `VARCHAR2(3)` | YES, if this copy has a retention policy different from the value for CONFIGURE RETENTION POLICY. Otherwise, NO.
`KEEP_UNTIL` | `DATE` | If the KEEP UNTIL TIME clause of the COPY command was specified, then this column shows the data after which this file copy becomes obsolete. If the column is NULL and KEEP_OPTIONS is not null, then this copy never becomes obsolete.
`KEEP_OPTIONS` | `VARCHAR2(10)` | The KEEP options specified for this datafile copy. Possible values are LOGS (RMAN keeps the logs needed to recover this backup), NOLOGS (RMAN does not keep the logs needed to recover this backup), or NULL (this backup has no KEEP options, and becomes obsolete based on the retention policy.)
`IS_RECOVERY_DEST_FILE` | `VARCHAR2(3)` | YES if this copy is located in the flash recovery area. Otherwise, NO.
`OUTPUT_BYTES_DISPLAY` | `VARCHAR2(4000)` | Same value as `OUTPUT_BYTES`, but converted to a user-displayable format, for example nM, nG, nT, nP.